package com.example.mapper;

import com.example.common.result.Result;
import com.example.entity.dto.LocationLabelDto;
import com.example.entity.vo.LocationLabelVo;
import com.example.entity.vo.WarehouseStockVo;
import com.example.entity.yifei.Cmsni;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.github.pagehelper.PageInfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 14501
* @description 针对表【CMSNI】的数据库操作Mapper
* @createDate 2024-08-08 08:40:00
* @Entity com.example.entity.yifei.Cmsni
*/
public interface CmsniMapper extends BaseMapper<Cmsni> {

    @Select("select top 1 NI002 FROM CMSNI WHERE NI001 = #{code}")
    String queryNI002String(String code);

    List<LocationLabelVo> getLocationLabel();

    List<WarehouseStockVo> getWarehouseStock(LocationLabelDto locationLabelDto);
}




